package com.ruoyi.slope.api.mapper;

import com.ruoyi.slope.api.domain.SlopeInfoDto;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SlopeInfoApiMapper {

    @Select("SELECT " +
            " si.slope_name AS slopename, " +
            " si.slope_code AS slopecode, " +
            " si.start_pile_no AS startpileno, " +
            " si.end_pile_no AS endpileno, " +
            " si.slope_height AS slopeheight, " +
            " si.slope_length AS slopelength, " +
            " si.route_code AS routecode, " +
            " si.route_name AS routename, " +
            " si.slope_features AS slopefeatures, " +
            " d.dept_name AS deptname, " +
            " sc.video_url AS videoAddress " +
            "FROM slope_info si " +
            "LEFT JOIN sys_dept d ON si.dept_id = d.dept_id " +
            "LEFT JOIN slope_camera sc ON si.slope_code = sc.slope_code")
    List<SlopeInfoDto> getSlopeInfoList();
}